Implementing Data Warehouses on AWS

Back to Home

01. Lesson Introduction
02. Data Warehouse: A Closer Look
03. Choices for Implementing a Data Warehouse
04. DWH Dimensional Model Storage on AWS
05. Amazon Redshift Technology
06. Amazon Redshift Architecture
07. Redshift Architecture Example
08. SQL to SQL ETL
09. SQL to SQL ETL - AWS Case
10. Redshift & ETL in Context
11. Ingesting at Scale
12. Redshift ETL Examples
13. Redshift ETL Continued
14. Redshift Cluster Quick Launcher
15. Exercise 1: Launch Redshift Cluster
16. Problems with the Quick Launcher
17. Infrastructure as Code on AWS
18. Enabling Programmatic Access fo IaC
19. Demo: Infrastructure as Code
20. Exercise 2: Infrastructure as Code
21. Exercise Solution 2: Infrastructure as Code
22. Demo: Parallel ETL
23. Exercise 3: Parallel ETL
24. Exercise Solution 3: Parallel ETL
25. Optimizing Table Design
26. Distribution Style: Even
27. Distribution Style: All
28. Distribution Syle: Auto
29. Distribution Syle: Key
30. Sorting Key
31. Sorting Key Example
32. Demo: Table Design
33. Exercise 4: Table Design
34. Exercise Solution 4: Table Design
35. Conclusion

Back to Home

05. Amazon Redshift Technology

L03-03-Part 1 Amazon Redshift Technology

Redshift

Which of the following statements are true about Redshift?

Column Oriented

Self-Managed

Massively Parallel

Runs one query on maximum one CPU

SOLUTION:

Column Oriented
Massively Parallel

Learn Udacity: click here to learn more :)